package com.vogue.supplymall.shop.domain.mapper;

import com.vogue.ssm.database.util.SqlLangDriver;
import com.vogue.supplymall.shop.domain.model.ProductPrice;

import java.util.List;

import org.apache.ibatis.annotations.Lang;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * The interface ProductPrice mapper.
 *
 * @Aouthor: gzl
 * @Date: Create in 2017-12-12
 */
@Mapper
public interface ProductPriceMapper extends BaseMapper<ProductPrice, Long> {
    /**
     * 根据syscodeid、productid、attrplanid、oneid(针对全部买家为0)
     */
	@Select("select * from product_price where syscodeid=#{arg0} and productid=#{arg1} and attrplanid=#{arg2} and oneid=#{arg3}")
	@Lang(SqlLangDriver.class)
	public List<ProductPrice> findProductPriceBySPAO(Long syscodeId,Long productId,Long attrplanId,Long oneId);
}
